const connection = require('../app/database')
class LabelService {
    async create(name) {
        const statement = `INSERT INTO label (name) VALUES (?)`
        const [result] = await connection.execute(statement, [name])
        return result
    }
    async getLabelByName(name) {
        const statement = `SELECT * FROM label WHERE name = ?;`
        const [result] = await connection.execute(statement, [name])
        return result[0]
    }
    async getLabels(limit, offset) {
        const statement = `SELECT * FROM label LIMIT ?,?;`
        const [result] = await connection.execute(statement, [offset, limit])
        return result
    }
}
module.exports = new LabelService()